
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspJob_UPDATE]
(
@jobId int = null,
@countryId int = null,
@regionId int = null,
@cityId int = null,
@fullName nvarchar(400) = null,
@abbreviation nvarchar(100) = null,
@isVisible bit = null,
@isDeleted bit = null,
@createDate AS datetime = null,
@lastModifiedDate AS datetime = null
)
AS

UPDATE
  [dbo].[Job]
SET
  [CountryId] = @countryId,
  [RegionId] = @regionId,
  [CityId] = @cityId,
  [FullName] = @fullName,
  [Abbreviation] = @abbreviation,
  [IsVisible] = @isVisible,
  [IsDeleted] = @isDeleted,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [JobId] = @jobId

GO
